if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetLogItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetLogItem]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


/***************************************************************************
* Name:			GetLogItems
* Purpose:		Fetch log items with LogItem ID
*
* PARAMETERS
* Name			Description					
* -------------		-----------------------------------------------------------
@LogItemId		LogItem Id for the LogItem to be fetched


***************************************************************************/
CREATE PROCEDURE [dbo].[GetLogItem]
(
@Id	int			
)
AS
BEGIN

	SET NOCOUNT ON

			Select	[Id],
				[QuestionnaireVersionId],
				questionnaireAnswerId,
				[Type],
				[Category],
				[QuestionName],
				[Answer],
				[Description],
				[Completed]
				
					
			FROM LogItem 

			WHERE [Id] = @Id  
	
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

